How can I extract segments from the string PR-2014-00006-02 into separate columns using SQL

Mastering Substring in SQL: Extracting Segments from Strings